

CREATE TABLE Users
(
    UserID                  INTEGER             PRIMARY KEY AUTOINCREMENT,
    UserName                varchar(50)         UNIQUE,
    PasswordHash            char(20)            NOT NULL,
    
    WithingsUserID          varchar(50)         ,
    WithingsPublicKey       varchar(50)         ,
    
    FatSecretOauthToken     varchar(50)         ,
    FatSecretOauthSecret    varchar(50)         ,
    
    FitbitOauthToken        varchar(50)         ,
    FitibtOauthSecret       varchar(50)         ,
    
    WeightService           varchar(50)         DEFAULT( 'None' ),
    FoodIntakeService       varchar(50)         DEFAULT( 'None' ),
    ExerciseService         varchar(50)         DEFAULT( 'None' )
    
);